{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["UserInput","CriteriaList","Dropdown"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"UserInput","index":0,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[27,1,28,7],[23,1,23,5],[22,1,22,5],[11,1,11,4],[13,1,13,4],[25,1,25,7],[15,1,15,4],[9,1,9,4],[17,1,17,4],[21,1,21,7],[19,1,19,4],[0,1,0,7],[1,1,1,7],[3,1,3,4],[5,1,5,4],[7,1,7,4],[2,1,2,7]]}
[null,"The Ohio Department of Transportation"]
[null,"Work Zone Speed Zone Evaluation Sheet (Form 1296-17)                                                                                                                                      for High-Speed (≥ 55 mph) Multi-Lane Highways"]
[]
[null,"County-Route-Section"]
[]
[null,"PID"]
[]
[null,"State Project Number"]
[]
[null,"Original Speed Limit (Pre-Construction)"]
[]
[null,"Length of Work Zone Condition\n(As defined by TEM 1203-2.9.1)"]
[]
[null,"Duration the Work Zone Condition\nis to remain in place"]
[]
[null,"Work Zone Condition* that reduces the existing functionality of the travel lanes or shoulders (i.e., lane closure, lane shift, crossover, contraflow and/or shouder closure)?"]
[]
[null,"Is there positive protection for workers?\n(As defined by TEM 1203-2.9.6)"]
[]
[null,"Will the qualifying Work Zone Condition and associated TTCDs remain in place when workers are not present?"]
[]
[null,"WARRANTED WORK ZONE SPEED LIMIT(S)"]
[null,{"$f":"IF(G23=\"\",\"\",(IF(G23=F10,\"No speed limit reduction; The speed limit remains the same as the original speed limit:\",\"When Workers ARE present and the qualifying Work Zone Condition IS IN PLACE:\")))","v":""},null,null,null,null,{"$f":"IF(OR(ISBLANK(F10),ISBLANK(F12),ISBLANK(F14),ISBLANK(F16),ISBLANK(F18),ISBLANK(F20)),\"\",IF(OR(F12=\"Less than 1/2 mile\", F14=\"Less than 3 hours\",F16=\"No\"),F10,IFERROR((INDEX(CriteriaList!$A$2:$D$17,MATCH(1,(CriteriaList!$A$2:$A$17=$F$10)*(CriteriaList!$B$2:$B$17=$F$18)*(CriteriaList!$C$2:$C$17=Dropdown!C3),0),4)),\"\")))","v":""},"MPH"]
[null,{"$f":"IF(G24=\"\",\"\",IF(F20=\"Yes\", \"When Workers ARE NOT present and the qualifying Work Zone Condition REMAINS IN PLACE:\", IF(F20=\"No\",\"When Workers ARE NOT present and the qualifying Work Zone Condition IS NOT IN PLACE:\",\"\")))","v":""},null,null,null,null,{"$f":"IF(OR(ISBLANK(F10),ISBLANK(F12),ISBLANK(F14),ISBLANK(F16),ISBLANK(F18),ISBLANK(F20),G23=F10),\"\",IF(ISBLANK(F20),\"\",IF(F20=\"No\",IF(OR(ISBLANK(F10),ISBLANK(F16),ISBLANK(F18)),\"\",F10),IFERROR((INDEX(CriteriaList!$A$2:$D$17,MATCH(1,(CriteriaList!$A$2:$A$17=$F$10)*(CriteriaList!$B$2:$B$17=$F$18)*(CriteriaList!$C$2:$C$17=Dropdown!C4),0),4)),\"\"))))","v":""},"MPH"]
[]
[null,{"$f":"IF(G23=F10,\"\",IF(G24=F10,\"\",\"REMINDER: When the qualifying work zone condition is no longer reducing the existing functionality          of the travel lanes or shoulders, the original, pre-construction, speed limit shall be displayed.\"))","v":""}]
[]
[null,{"$f":"IF(G23=\"\",\"\",(IF(F10=G23,\"THIS WORK ZONE DOESN'T QUALIFY FOR A WZSZ BASED UPON THE BASIC WORK ZONE CRITERIA PRESENTED. (LENGTH, DURATION AND THE CONDITION'S IMPACT ON THE TRAVEL LANES OR SHOULDERS)\",\"All WZSZs are variable in nature regardless of the type of signage used. See TEM 640-18.2.6 and 640-18.2.7 for additional information regarding the sign type to use for implementation of this WZSZ.\")))","v":""}]
[]
[]
[]
[null,"Notes:"]
[null,"Positive Protection is generally regarded as portable barrier or other rigid barrier along the work area."]
[null,"Without Positive Protection is generally regarded as using drums, cones, shadow vehicles, etc, along the work area."]
[null,"Only one warranted speed limit applies at any one time. Speed limit reductions are not cumulative."]
[null,"TTCD = Temporary Traffic Control Device"]
[null,"See TEM Section 1203-2.9.6 for definitions and additional guidance. "]
[null,"*Moving/Mobile activities (as defined by the OMUTCD) are not included. WZSZ shall not be used for these activities."]
[null,null,null,null,null,null,null,"Form Revised: 10/16/15"]

{"sheet":"CriteriaList","index":1,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["Original Posted Speed Limit","Positive Protection Present","Workers Present","Approved Speed Limit"]
[55,"Yes","Yes",50]
[55,"Yes","No",55]
[55,"No","Yes",45]
[55,"No","No",55]
[60,"Yes","Yes",55]
[60,"Yes","No",60]
[60,"No","Yes",50]
[60,"No","No",60]
[65,"Yes","Yes",55]
[65,"Yes","No",60]
[65,"No","Yes",50]
[65,"No","No",60]
[70,"Yes","Yes",60]
[70,"Yes","No",65]
[70,"No","Yes",55]
[70,"No","No",65]
[]
[]
["Password to unlock: WZSZ"]

{"sheet":"Dropdown","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Speed Limit","Work Zone Condition","Workers","Positive Protection ","Length","Duration"]
[]
[55,"Yes","Yes","Yes","Less than 1/2 mile","Less than 3 hours"]
[60,"No","No","No","1/2 mile or greater","3 hours or greater","No"]
[65]
[70]
[]
[]
["Password to unlock: WZSZ"]